Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
RewardDerivationRuleEligibilityID (FK) | A unique identifier for a Price Derivation Rule Eligibility. | ID_EL_PRDV | Identity | integer | ZPromotionalOfferRewardDerivationRule(RU_PRM_PRDV) |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | |
RetailTransactionLineItemSequenceNumber (FK)(PK) | The sequence number of line item within the context of this RetailTransaction. | IC_LN_ITM | LineNumber | smallint | |
PriceModificationTypeCode (FK) | The type code used as a look up key for the standard price modification types represented in the Price Modification. | TY_MDF | Code2 | char(2) | PriceModificationType(TR_MDF) |
ModifyByPercent | The percent adjustment that was applied to the unit retail price to arrive at the modified selling price. Example Base price $10.00 ModifyByPercent 5% (.05) Price Modification to be applied is $.50 | PE_MDFR_RT_PRC | Percent | decimal(7,4) | |
ModifyByAmount | A flat monetary value that is to be added to or subtracted from a base price. (Note typically this is a discount so subtraction is the expected action) Example: Base price $10.00 ModifyByAmountt $.50 Price Modification to be applied is $.50 | MO_MDFR_RT_PRC | Money | decimal(16,5) | |
NewPriceAmount | The amount expressed as the new price for the item. | MO_NW_PRC | Money | decimal(16,5) | |
ProRatedFlag | Indicates if this price modification was pro-rated across all of the Items in the RetailTransaction. | FL_PRRT | Flag | integer | |
PriceModificationBaseAmount | The monetary value of the transaction (i.e. a sum of sale return line item extended actual retail amounts) plus or minus other PriceModificationLineItem values used as the basis for this price modifciation calculation. NOTE: The ARTS model defines placeholders for transaction-level discounts. However, it is the retailer's responsibility to specify the business rules for calculating transaction-level price modificaction values and to assign an appropriate value to PriceModificationBaseAmount. | MO_PRC_MDFN_BS_AMT | Money | decimal(16,5) | |
AdjustmentMethodCode | A symbol code denoting what kind of adjustment is being made to the retail price of the Item. e.g. Increase, Decrease. '+' = Add to base retail (amount before price modifier '-' = Subtract from base retail '=' = Replace base retail with ModifyByAmount | CD_MTH_ADJT | Code2 | char(2) | |
Description | Business description of a retail price modifier that may be used to store special discount-related messages that may be printed on the receipt. | DE_TR_LTM_MDF | DescriptionShort | varchar(255) | |
RoundingAmount | The monetary amount that the price modification was adjusted by (after calculation from the percentage). | MO_RND | MoneyShortRetail | decimal(7,2) | |
UnusedCouponReasonDescription | Reason explanation for return of a coupon. This short narrative is used to document the rationale for returning a retailer coupon to a customer. Sample reasons include: Coupon out of date Out of stock-no rainchecks | DE_UNUSD_CPN_RSN_DSCR | DescriptionShort | varchar(255) | |
UnusedCouponFlag | Boolean indicator that if true means a store coupon LINE ITEM was submitted that could not be applied and is being returned to a customer (applies to electronic or paper coupons issued by the retailer) | FL_UNUSD_CPN_FL | Flag | integer | |
RewardID (FK) | A token identifier for a Reward instance. | ID_RWD | Identity | integer | Reward(TR_RWD) |